home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.cs.arizona.edu
/
ftp.cs.arizona.edu.tar
/
ftp.cs.arizona.edu
/
icon
/
newsgrp
/
group95b.txt
/
000056_icon-group-sender _Mon Jun 19 11:39:28 1995.msg
< prev
next >
Wrap
Internet Message Format
|
1995-09-18
|
3KB
Received: by cheltenham.cs.arizona.edu; Mon, 19 Jun 1995 12:26:33 MST
Date: Mon, 19 Jun 1995 11:39:28 -0600 (CST)
From: Chris Tenaglia | 456-8765 <TENAGLIA@MIS.MCW.EDU>
Subject: Re: ICON and Data Conversion
To: dcorbo@ix.netcom.com
Cc: icon-group@cs.arizona.edu
Message-Id: <01HRW05Y280I8WWUVE@mis.mcw.edu>
Organization: Medical College of Wisconsin (Milwaukee, WI)
X-Vms-To: IN%"dcorbo@ix.netcom.com"
X-Vms-Cc: IN%"icon-group@cs.arizona.edu"
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; CHARSET=US-ASCII
Content-Transfer-Encoding: 7BIT
Errors-To: icon-group-errors@cs.arizona.edu
Exactly what I use it for. There's a ton of tools available
like Perl, Icon, and AWK. One seems to pick one and use it
like a swiss army knife. I use icon as my preferred tool.
I've used it for reconciling employee records against the
password file to make sure only current employees have
accounts. I've made data viewers for cobol programmers.
They supply a cobol FD (file def) section, and a data file
name and my viewer shows how the data elements fit in the
field. Good for checking alignments, empty fields, and ranges.
I've written mailing label generators, and printer filters too.
Chris Tenaglia (System Manager) | "The past explained,
Medical College of Wisconsin | the future foretold,
8701 W. Watertown Plank Rd. | the present largely appologized for."
Milwaukee, WI 53226 | Organon to The Doctor
(414)456-8765 |
tenaglia@mis.mcw.edu
> From: IN%"dcorbo@ix.netcom.com" 19-JUN-1995 11:14:39.26
> To: IN%"icon-group@cs.arizona.edu"
> Subj: ICON and Data Conversion
> In the last few years, I've worked on several downsizing and data
> warehouse projects. One of the requirements is always to take mainframe
> information and convert it into some format that can be loaded into the
> new system database, usually UNIX based but I suspect I'll be working
> with NT soon. When I perform this work, I require the delivery of a
> plain ascii text file. I then use KSH with PERL or AWK to parse the
> file and create the file(s) for loading. Some of the conversion
> processing involves creating relationships with several other files or
> database tables for referential integrity or looking up descriptive
> data, etc. I am always looking for good tools that can make my work
> easier and of better quality. I would like to know if ICON is suitable
> for this type of work.
> Dennis Corbo